How to Join Multiple Tables and Retrieve Specific Columns in SQL Server?

Question

Ravi Vishwakarma · Answer

To 
join multiple tables and retrieve specific columns in SQL Server, you can use the
INNER JOIN clause (or other types of joins as needed).and 
Here is an example query to join the Customers, Orders, and
Products tables and retrieve the columns CustomerName, 
OrderID, ProductName, and OrderDate.
SELECT 
    CS.name AS CustomerName, -- Alise name of CS.name
    Odr.OrderID, -- OrderID from Orders Alise 'Odr'
    Products.ProductName,
    Odr.OrderDate
FROM 
    Customer AS CS -- Alise of Customer table
INNER JOIN 
    Orders AS Odr ON CS.ID = Odr.Id
INNER JOIN 
    Products ON Odr.ProductID = Products.ProductID;
In this query:
Customers is joined with Orders using the CustomerID column.Orders is joined with Products using the ProductID column.Specific columns from each table are selected in the SELECT statement.
Read more
How to use searching and filtering data in an SQL server?
How do I write CRUD operations to modify data in SQL Server tables?
What is SQL Keys and why is the use of it?
and

forum

How to Join Multiple Tables and Retrieve Specific Columns in SQL Server?

Anubhav Kumar

Can you answer this question?

1 Answers

Liked By